Hệ thống quản lý phương tiện trực tuyến bằng PHP

7.253 lượt xem;

orderedspareparts.php
project /

1 <?php
2 include("header.php");
3 include("sidebar.php");
4 include("dbconnection.php");
5 ?>
6 <script language="javascript" type="text/javascript">
7         function printDiv(divID) {
8             //Get the HTML of div
9             var divElements = document.getElementById(divID).innerHTML;
10             //Get the HTML of whole page
11             var oldPage = document.body.innerHTML;
12
13             //Reset the page's HTML with div's HTML only
14             document.body.innerHTML =
15               "<html><head><title></title></head><body>" +
16               divElements + "</body>";
17
18             //Print Page
19             window.print();
20
21             //Restore orignal HTML
22             document.body.innerHTML = oldPage;
23
24
25         }
26     </script>
27 <?php
28 $sql = mysql_query("select * from spareparts where spid=$_POST[spid]");
29 $row = mysql_fetch_array($sql);
30
31 if(isset($_POST["submit"]))
32 {
33 $dt = date("Y-m-d");
34 $sql ="insert into sparepartsorder(spid,custid,orderdate,noofitems,status) values('$_POST[spid]','$_SESSION[custid]','$dt','$_POST[noofitems]','Pending')";
35
36 if (!mysql_query($sql,$con))
37   {
38   die('Error: ' . mysql_error());
39   }
40 }
41 ?>
42
43         <div id="main">
44              <div id="printablediv" style="width: 100%;">
45         <h3>Ordered spare part report</h3>
46
47
48         <table width="538" border="1">
49           <tr>
50             <td height="45" colspan="2"><h2>Spare Parts booked successfully...</h2></td>
51           </tr>
52           <tr>
53             <td width="268">
54             <p><img src="upload/<?php echo $row['image']; ?>" width="208" height="130" align="left" /><br />
55               <br />
56             </p></td>
57             <td width="246"><p><strong>SparePart Name:</strong><?php echo $row['name']; ?><br />
58               <strong>type:</strong> <?php echo $row['type']; ?> <br />
59               <strong>SparePart No:</strong> <?php echo $row['sparepartno']; ?><br />
60               <br />
61               <br />
62             </p></td>
63           </tr>
64           <tr>
65             <td>Other Information</td>
66             <td><p><?php echo $row['description']; ?></p><br />
67               </td>
68           </tr>
69               <tr>
70             <td colspan="2"><strong>Total Amount: Dhs. <?php echo $_POST[noofitems] * $row['cost']; ?></strong></td>
71           </tr>
72           <tr>
73             <td height="23" colspan="2" align="center"><a href='#' onclick="javascript:printDiv('printablediv')" ><strong>Print purchase report..</strong></a></td>
74           </tr>
75           </table>
76         </div>
77
78 
79 </div>
80
81 <?php
82 include("footer.php");
83 ?>